A Data Warehouse Engineering Process
نویسندگان
چکیده
Developing a data warehouse (DW) is a complex, time consuming and prone to fail task. Different DW models and methods have been presented during the last few years. However, none of them addresses the whole development process in an integrated manner. In this paper, we present a DW development method, based on the Unified Modeling Language (UML) and the Unified Process (UP), which addresses the design and development of both the DW back-stage and front-end. We extend the UML in order to accurately represent the different parts of a DW. Our proposal provides a seamless method for developing DWs.
منابع مشابه
A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse
Building a data warehouse is a very challenging issue because compared to software engineering it is quite a young discipline and does not yet offer well-established strategies and techniques for the development process. Current data warehouse development methods can fall within three basic groups: data-driven, goal-driven and user-driven. All three development approaches have been applied to t...
متن کاملDWPPT: Data Warehouse Performance Prediction Tool
The increasing demands for interactive response time from the users makes query performance one of the central problems of Data warehouse systems today. Performance is an important quality aspect of Data warehouse systems. Predicting the performance of Data warehouse systems during early design stages of their development is significant. Software Performance Engineering(SPE) promotes the idea t...
متن کاملFuzzy multi-criteria selection procedures in choosing data source
Technology assessment and selection has a substantial impact on organizations procedures in regards to technology transfer. Technological decisions are usually made by a group of experts, and whereby integrity of these viewpoints to a single decision can be quite complex. Today, operational databases and data warehouses exist to manage and organize data with specific features and henceforth, th...
متن کاملDWARF: AN Approach for Requirements Definition and Management of Data Warehouse Systems
In the novel domain of Data Warehouse Systems, software engineers are required to define a solution that integrates with a number of heterogeneous sources to extract, transform and aggregate data, as well as offers flexibility to run ad-hoc queries that retrieve analytic information. Moreover, these activities should be performed based on a concise dimensional schema. This intricate process wit...
متن کاملData Warehouse Design and Optimization for Drilling Engineering
With the development of petroleum informatization and increase of drilling data, data storage, analysis and integration is attached to the key planning process. Therefore, a solution is needed which combines the data integration, management, analysis and decision support. Data warehouse is one of the hot topics in computer technology application, which has solved the problem of data using after...
متن کاملUML for data warehouse dimensional modeling
Dimensional modeling is a common modeling technique in data warehousing. It reflects a simple logical view of a data warehouse system. It can be easily mapped to a physical design. Traditional dimensional modeling is data-oriented and semantically informal. From a software engineering perspective, the informal notations and data-oriented feature are insufficient to tackle the complexity of larg...
متن کامل